<?php
header("Content-type: text/html; charset=utf-8");

require('../dbconnect.inc.php');

$use_opt = false;

$rs = $dbh->query('select c_id,location from network_map order by c_id');

$alldb = $rs->fetchAll(PDO::FETCH_ASSOC);

foreach( $alldb as $key => $val)
{
	echo '<option value=' . $val['c_id'] . '> ' . $val['c_id'] . (empty($val['location'])? '' : '-'. $val['location']) . "</option>\n";
}

?>
